2016-06-29 - 26510 - Spec - Create AR universe measures #universe
SPECIFICATIONS
26510 - Create AR universe measures
Requirement Summary
Need to c
reate universe measures on AR datasource.
Admin Info
Purpose
|
Need to create universe measures on AR datasource.
|
Requested By
|
Jayson Osmars
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
06/29/2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
VFIAR_C03
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
16
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
80
|
4
|
Unit test in DEV
|
20
|
5
|
Unit test in QUA
|
00
|
6
|
BW Key Figures
|
36
|
|
TOTAL
|
160
|
References
Prior Tickets
26510.100
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1.
|
Performance testing on the AR with WEBI and Explorer.
|
Jayson Osmars
|
09/14/2016
|
Through IM
|
2.
|
The users have asked if there's an indicator if a customer is on credit block?
Can you find what that is in the AR universe?
|
Jayson Osmars
|
10/03/2016
|
Through IM
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to c
reate universe measures on AR datasource.
In Scope:
Need to c
reate universe with calculated measures and optional prompts
on AR datasource.
Out of Scope:
Currency Conversion is not handled in universe.
Solution Summary
1. Need to create data connections based on required cube.
2. Need to create data foundation by using data connections.
3. Need to create Business Layer by using data foundations.
4. Need to develop Information space based on Universe.
5. Need to create Explorer reports based on Information Space.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Need to test whether the report data matches with BW Cube.
|
Data should be validated successfully.
|
2
|
Check if the optional prompts are working correctly.
|
Optional prompts should be validated successfully.
|
3
|
Create the information space in NEC BI Explorer.
|
information space should execute successfully in NEC BI Explorer.
|
Solution Details
1. Created data connections based on required cube(VFIAR_C03).
2. Created data foundation by using data connections.
3. Created business Layer by using data foundations.
4. Added the following optional prompts to Business layer:
i. Company Code.
ii. Fiscal Year Variant.
iii. Sales Rep.
iv. Customer.
5. Created Information space based on AR Universe.
Issues
Customer Credit Logic implementation is complex in universe and Information space indexing has poor performance on BW cube source.